IF exists(SELECT * FROM dbo.sysobjects WHERE name='vulJh' AND xtype='P') 
BEGIN
	DROP PROCEDURE vulJh
END
GO

CREATE   procedure vulJh
as
update hogeVenen
set JH=h.JH,tocht=h.tocht
from hogeVenen as v
   	left join hogeVenenKlas as h
   on h.klas = v.klas